create  view vGreatestGift as
    select v.ID,
           max(v.TRANSACTION_DATE) as TRANSACTION_DATE,
           v.AMOUNT
    from vCashGiftTotals v
    group by v.ID, v.AMOUNT having v.AMOUNT >=
             (select max(v2.AMOUNT)
              from vCashGiftTotals as v2
              where v2.ID = v.ID )

GO
GRANT REFERENCES ON  [dbo].[vGreatestGift] TO [IMIS]
GRANT SELECT ON  [dbo].[vGreatestGift] TO [IMIS]
GRANT INSERT ON  [dbo].[vGreatestGift] TO [IMIS]
GRANT DELETE ON  [dbo].[vGreatestGift] TO [IMIS]
GRANT UPDATE ON  [dbo].[vGreatestGift] TO [IMIS]
GO